[dbo].[asi_InsertChangeProperty]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_InsertChangeProperty

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@logKey	uniqueidentifier	16
@propertyName	nvarchar(100)	200
@originalValue	nvarchar(250)	500
@originalDesc	nvarchar(250)	500
@currentValue	nvarchar(250)	500
@currentDesc	nvarchar(250)	500

SQL Script

CREATE PROCEDURE [dbo].[asi_InsertChangeProperty]

@logKey uniqueidentifier,
@propertyName nvarchar(100),
@originalValue nvarchar(250),
@originalDesc nvarchar(250),
@currentValue nvarchar(250),
@currentDesc nvarchar(250)

AS

INSERT
    ChangeProperty (ChangeLogKey, PropertyName, OriginalValue, OriginalDescription, CurrentValue, CurrentDescription)
    VALUES
    (@logKey, @propertyName, @originalValue, @originalDesc, @currentValue, @currentDesc)

GO

Uses

[dbo].[ChangeProperty]
dbo